SELECT
CONCAT( "" ,
d.document_no, "" ) As "view",
CONCAT( "edit" ) As "edit",
CONCAT( "" ,
dm.demographic_no, "" ) As "Dem#",
CONCAT( "eChart" ) AS "eChart" ,
d.docdesc As "Doc_descripton",
d.observationdate as "Date",
d.doccreator as "Creator",
dm.last_name "Last",
dm.first_name "First",
CONCAT(dm.year_of_birth,'-',dm.month_of_birth,'-',dm.date_of_birth) AS "DOB",
dm.sex AS "G",
dm.hin,
dm.phone,
CONCAT( "" ,dm.email, "" ) as "emailto",
dm.phone2,
dm.address,
CONCAT(dm.city," ",dm.postal) as citypostal
FROM demographic dm, document d, ctl_document cd
WHERE
dm.demographic_no = cd.module_id
AND
d.document_no = cd.document_no
AND
(d.docfilename LIKE REPLACE("%{docname}%"," ","%")
OR
d.docdesc LIKE REPLACE("%{docname}%"," ","%") )
Order by d.document_no desc {limitnumresult};
%
100
10
500
1000
ALL